﻿use cosea_reclutamiento

select * from Usuario
select * from GruposUsuarios
select * from Modulos
select * from GrupoUsuario
select * from GrupoModulo

---
--update persona set fechaalta = GETDATE () where idpersona = 'A0F8FC1A-66AD-DF11-BC3A-005056C00008'
--update Candidato set fechaalta = GETDATE () where idpersona = 'A0F8FC1A-66AD-DF11-BC3A-005056C00008'
select *
from FoliadorOT 
select * 
--delete
from Empresa 

select * 
--delete
from Persona 
where idpersona =  '301AB5D6-711C-E011-9125-0019B91554DB'
select * 
--delete
from candidato
where idpersona = 'A0F8FC1A-66AD-DF11-BC3A-005056C00008'
select * 
--delete 
from OrdenTrabajo
select * 
--delete
from Curriculum
select * 
--delete
from EntrevistaCosea
select * 
--delete
from ImagenPersona
where idpersona <> 'A0F8FC1A-66AD-DF11-BC3A-005056C00008'
select * 
--delete
from Estudios
select * 
--delete
from Experiencia
select * 
--delete
from DatosFamiliaresEntreCosea
select * 
--delete
from ExperienciaLaboralEntreCosea
select * 
--delete
from HermanosEntreCosea
select * 
--delete 
from HijosEntreCosea